package com.jxc.model.po;

import java.io.Serializable;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Table;

@Entity
@Table(name="jhtj")
public class Jhtj extends IdEntity implements Serializable{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	/*
	 * jhtj视图语句:
	 * create or replace view jhtj  as 
	 * select u.user_id userid, u.real_name realname,sum(oli.num) jhsum 
	 * from rkgl_orderlist_item oli,rkgl_orderlist ol,qxgl_user u 
	 * where ol.id=oli.ORDERLIST_ID and ol.user_id=u.id and  u.user_id in
	 * (select id from qxgl_user where user_type=1) group by userid
	 */
	private Long userid;
	private Double jhsum;
	private String realname;
	@Column(name = "userid")
	public Long getUserid() {
		return userid;
	}
	public void setUserid(Long userid) {
		this.userid = userid;
	}
	@Column(name = "jhsum")
	public Double getJhsum() {
		return jhsum;
	}
	public void setJhsum(Double jhsum) {
		this.jhsum = jhsum;
	}
	@Column(name = "realname")
	public String getRealname() {
		return realname;
	}
	public void setRealname(String realname) {
		this.realname = realname;
	}
	

}
